SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweEspacio
AS
SELECT     idEspacio AS ID, TurnosDisponibles, CapOcupadaM, CapOcupadaT, CapOcupadaV, CapOcupadaN, TipoDeEspacio, Superficie, Planta, Cantidad, 
                      TipodeTecho, TipodeParedes, TipodeCarpinteria, TipodePiso, TipodeCielorraso
FROM         dbo.tb_Espacios
GO
GRANT SELECT ON  [dbo].[vweEspacio] TO [LegajoEdilico]
GRANT INSERT ON  [dbo].[vweEspacio] TO [LegajoEdilico]
GRANT DELETE ON  [dbo].[vweEspacio] TO [LegajoEdilico]
GRANT UPDATE ON  [dbo].[vweEspacio] TO [LegajoEdilico]
GRANT SELECT ON  [dbo].[vweEspacio] TO [SoloVer]
GO
